{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Tool","Review"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[29,1,29,25],[2,7,3,19],[9,1,9,25],[13,1,13,25],[15,1,15,24],[21,1,21,25],[24,1,24,25]]}
[]
[]
[null,null,null,null,null,null,null,"CATEGORY P ROAD & PATHWAY CLASSIFICATION & CALCULATOR TOOL"]
[]
[]
[null,"This P category road & pathway calculator calculates the lighting subcategory (PR1-6 / PP1-5) which is applicable to a P category road / path for lighting."]
[null,"This P subcategory selection tool has been developed to help to interpret the selection criteria outlined in AS/NZS 1158.3.1 Table 2.1 and Table 2.2.  It should be used as a guide only.  "]
[null,"The resulting subcategory should be considered against the recommendations in Table 2.1 and Table 2.2 and the characteristics of the actual site."]
[]
[null,"INSTRUCTIONS"]
[null,"To start the Subcategory P Selection Tool select the Instructions tab at bottom of this sheet.  Read notes below before starting."]
[null,"Before using this Selection Tool first determine if the road needs Category P lighting or not."]
[]
[null,"NOTES"]
[]
[null,"This calculator takes road parameter as inputs from the user and calculates the appropriate p road subcategory. The selection criteria and calculation procedure is based on NZS 1158.3.1:2020 standard."]
["                      To operate this calculator, select the Sheet1 tab at the bottom and select the type of the road from the road category. Also an example of road types and indicative lighting categories have been shown in Figure 1 which is available in the Appendix sheet.","To operate this calculator, select the Calculator tab at the bottom and select the type of the road from the road category. "]
[null,"Choose appropriate levels of pedestrian/cycle activity, risk of crime, need to enhance prestige in the selection criteria. "]
[null,"On selecting the appropriate levels in the selection criteria column, the appropriate P subcategory level will be displayed in the Lighting category recommendation column."]
[null,"It should be noted that the result obtained from this calculator is only preliminary and that the final decision should be made by referring to the AS/NZS 1158.3.1 standard."]
[]
[null,"PEDESTRIAN/CYCLE ACTIVITY:"]
[null,"Choose the appropriate level of Pedestrian/Cycle activity on the street from high, medium and low levels ."]
[]
[null,"RISK OF CRIME:"]
[]
[null,"This criterion has been introduced so that a level of lighting may be selected in order to mitigate actual or perceived crime."]
[null,"The following website may be helpful in determining the nominal level of risk : https://insights.nzherald.co.nz/apps/crime_maps/crime/index.html "]
[]
[null,"NEED TO ENHANCE PRESTIGE:"]
[]
[null,"This criterion has been introduced so that a level of lighting maybe selected where a higher degree of prestige and amenity is desired, e.g. in a new housing development or in a refurbishment of a civic area."]
[null,"The lighting will often be one of a number of items being implemented to enhance prestige."]

{"sheet":"Tool","index":1,"n_rows":41,"n_cols":42,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,5,2,16],[27,17,29,19],[27,20,29,20],[40,1,40,13],[29,4,33,7],[29,11,33,13],[29,8,33,10],[34,4,39,7],[34,8,39,10],[34,11,39,13],[8,15,9,18],[8,19,9,20],[26,4,28,7],[26,8,28,10],[26,11,28,13],[8,21,9,23],[4,5,4,12],[22,15,23,23],[10,4,17,7],[10,8,17,10],[10,11,17,13],[18,4,25,7],[18,8,25,10],[18,11,25,13],[4,2,4,4],[8,1,9,3],[8,4,9,7]]}
[]
[]
[null,null,null,null,null,"Category P Road & Path Classification & Calculator Tool",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2020-10-15"}]
[]
[null,null,"Road/Path Name:"]
[]
[]
[null,null,null,null,null,null,"Select the type of road from the following:",null,null,null,null,null,null,null,null,null,null,null,"Selection Criteria",null,null,null,null,null,null,null,2,null,null,null,"Pedestrian",null,"Crime",null,"Prestige"]
[null,"Road Type",null,null,"Description:",null,null,null,null,"Traffic Flow",null,null,"Basic operating",null,null,"Pedestrian / cycle activity",null,null,null,"Fear of crime",null,"Need to enhance prestige",null,null,null,null,1,null,null,"Collector Road","High",2,"High",1,"High",2,null,1,"Collector","Pedestrian","Crime","Prestige"]
[null,null,null,null,null,null,null,null,null,"(vehicles/day)",null,null," characteristics",null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,"Medium",3,"Medium",2,"Medium",3,null,null,{"$f":"IF(SUM(AN10:AP10)=0,\"\",IF(AND(AN10=4,AO10=3,AP10=5),$AK$24,\"PR\"&MIN(AN10,AO10,AP10)))","v":""},{"$f":"IF($AA$8=AL9,CHOOSE($AA$9,AF12,AF9,AF10,AF11),\"\")","v":""},{"$f":"IF($AA$8=AL9,CHOOSE($AA$10,AH9,AH10,AH11),\"\")","v":""},{"$f":"IF($AA$8=AL9,CHOOSE($AA$11,AJ11,AJ9,AJ10),\"\")","v":""}]
[null,null,null,null,"• Collector Roads or non-arterial roads which collect and distribute traffic in an area, as well as serving abutting properties.\n• Provide connections between areas of the City and the arterial roadnetwork.\n• Road reserve widths of 17m to 20m.",null,null,null,"3000 to 1000",null,null,"• Mixed vehicle and pedestrian traffic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,"Low",4,"Low",3,"NA",5,"PR4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NA",5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian",null,"Crime",null,"Prestige"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local","High",2,"High",1,"High",2,null,2,"Local","Pedestrian","Crime","Prestige"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium",3,"Medium",2,"Medium",3,null,null,{"$f":"IF(SUM(AN16:AP16)=0,\"\",IF(AND(AN16=3,AO16=2,AP16=3),$AK$24,\"PR\"&MIN(AN16,AO16,AP16)))","v":"PR4"},{"$f":"IF($AA$8=AL15,CHOOSE($AA$9,AF18,AF15,AF16,AF17),\"\")","v":5},{"$f":"IF($AA$8=AL15,CHOOSE($AA$10,AH15,AH16,AH17),\"\")","v":4},{"$f":"IF($AA$8=AL15,CHOOSE($AA$11,AJ17,AJ15,AJ16),\"\")","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low",4,"Low",4,"NA",5,"PR3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NA",5]
[null,null,null,null,"• Local roads or streets used primarily for access to abutting properties,including residential properties.\n• Collect and distribute traffic to and from other streets within the local area.\n• Road reserve widths of 14m to 20m.\n• Short cul-de-sacs of 12m or more.",null,null,null,"Less than 1000",null,null,"• Mixed vehicle and pedestrian  traffic with more emphasis towards pedestrian movements"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian",null,"Crime",null,"Prestige"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Common","High",2,"High",1,"High",2,null,3,"Common","Pedestrian","Crime","Prestige"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIGHTING CATEGORY RECOMMENDATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium",3,"Medium",2,"Medium",3,null,null,{"$f":"IF(SUM(AN23:AP23)=0,\"\",IF(AND(AN23=4,AO23=3,AP23=5),$AK$24,\"PR\"&MIN(AN23,AO23,AP23)))","v":""},{"$f":"IF($AA$8=AL22,CHOOSE($AA$9,AF25,AF22,AF23,AF24),\"\")","v":""},{"$f":"IF($AA$8=AL22,CHOOSE($AA$10,AH22,AH23,AH24),\"\")","v":""},{"$f":"IF($AA$8=AL22,CHOOSE($AA$11,AJ24,AJ22,AJ23),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low",4,"Low",3,"NA",5,"PR4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NA",5]
[]
[null,null,null,null,"• Common area, forecourts of cluster housing.",null,null,null,"N/A",null,null,"Mixed vehicle and pedestrian  traffic"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P CATEGORY:",null,null,{"$f":"IFERROR(CHOOSE($AA$8,AM10,AM16,AM23,AM30),\"\")","v":"PR4"},null,null,null,null,null,null,null,null,null,"Pedestrian",null,"Crime",null,"Prestige"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian","High",2,"High",1,"High",2,null,4,"Pedestrian","Pedestrian","Crime","Prestige"]
[null,null,null,null,"• Pedestrian or cycle orientated pathway, eg. Foothpaths, including those along local roads and arterial roads, walkways, lanes, park paths,cycleways.",null,null,null,"N/A",null,null,"Pedestrian/ cycle traffic only",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium",3,"Medium",2,"Medium",3,null,null,{"$f":"IF(SUM(AN30:AP30)=0,\"\",IF(AND(AN30=4,AO30=3,AP30=5),$AK$31,\"PP\"&MIN(AN30,AO30,AP30)))","v":""},{"$f":"IF($AA$8=AL29,CHOOSE($AA$9,AF32,AF29,AF30,AF31),\"\")","v":""},{"$f":"IF($AA$8=AL29,CHOOSE($AA$10,AH29,AH30,AH31),\"\")","v":""},{"$f":"IF($AA$8=AL29,CHOOSE($AA$11,AJ31,AJ29,AJ30),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low",4,"Low",3,"NA",5,"PP4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NA",5]
[]
[]
[null,null,null,null,"• Roads within the area designated \"rural\" on the District Plan.\n• Primary function to provide access to rural properties.\n• No Pedestrian facilities available",null,null,null,"N/A",null,null,"Mixed vehicle and pedestrian traffic"]
[]
[]
[]
[]
[]
[null,{"$f":"IF($AA$8=5,\"Refer to the AS/NZS 1158 Part 1 - V Category Lighting\",\"\")","v":""}]

{"sheet":"Review","index":2,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
[]
["Revision Table"]
["Version","Date","Changes"]
[1,"2020-10-15","Original issue"]